Overview
The Stocktake Audit Report compares current stock on hand to what is reported to be on hand. Its purpose is
Custom terminology allows you to define the retail terminology used within your business. Once defined, terminology automatically appears on criteria forms and reports. For more information on defining custom terminology refer to the article Custom Terminology.
Criteria Form
Refer to the article Report Criteria Form Standard Field Operation for help with the standard criteria form fields.
The following table describes the operation of non-standard fields where appropriate.
| Field | Description |
|---|---|
| Show Stock Take Adjustments | This check box indicates whether the report will show all stock gains and losses as a result of a stock take. Either this box or the Show Stock Adjustments box must be checked. |
| Show Stock Adjustments | This check box indicates whether the report will show all manual stock write-ups and write downs. Either this box or the Show Stock Take Adjustments box must be checked. |
| Report By | This drop-down field identifies the costing that should be used in the report. |
| Drill By | This drop-down field defines the first column in the report. It identifies the column that can be drilled down on in the report. |
Reports
Refer to the section Understanding the Intelligence Store Data for help with the standard values included in Retail Arena reporting.
The following table describes non-standard columns where appropriate.
| Column | Description |
|---|---|
| Store Code or Department Description or Size |
This column shows the selection in Drill By and the hyperlinks may be clicked on to drill down further into the report. |
| Abs $ Var Cost | This column shows the absolute dollars variance cost. |
| Act $ Var Cost | This column shows the actual dollar variance cost. |
| Abs % Var Cost | This column shows the absolute variance cost percentage. |
| Shrink % Cost | This column shows the actual dollar variance cost divided by the sale value. |
| Count | This column shows the stocktake count. |
| Net Unit adj | This column shows positive unit adjustments minus the negative unit adjustments. |
| Neg Unit adj | This column shows the number of items that cannot be accounted for. |
| Pos Unit adj | This column shows the number of extra items that cannot be accounted for. |
| Absolute Unit Var | This column shows the negative unit adjustments plus the positive unit adjustments. |
| Actual Unit Var | This column shows minus negative unit adjustments plus positive unit adjustments. |
| SOH Pre Stock Take | This column shows the stock on hand pre stock take. |
| Cls Stk Qty | This column shows the closing stock quantity. |
| Cost $ | This column shows the actual cost pre-adjustment. |
| Adjusted Cost $ | This column shows the actual cost post-adjustment. |
Remarks
Technical Reference
This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.
| Property | Value |
| Form Name | Arena_StocktakeAudit |
| Form Customization JScript File Name | Arena_StocktakeAudit.js |
| Report Definition Name | Arena_StocktakeAudit |
| Permission Name | Arena_StocktakeAudit |
| Property | Value |
| RDL Name | StocktakeAuditbyStore.rdl |
| Stored Procedure Name | Arena_StockTakeReport |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | Yes |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | Yes |
| Supports Currency Conversion | No |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No however non-inventory items are explicitly excluded in the query. |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |
| Property | Value |
| RDL Name | StocktakeAuditbyDepartment.rdl |
| Stored Procedure Name | Arena_StockTakeReport |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | Yes |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | Yes |
| Supports Currency Conversion | No |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No however non-inventory items are explicitly excluded in the query. |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |
| Property | Value |
| RDL Name | StocktakeAuditbySize.rdl |
| Stored Procedure Name | Arena_StockTakeReport |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | Yes |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | Yes |
| Supports Currency Conversion | No |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No however non-inventory items are explicitly excluded in the query. |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |